48. Solutions: OR

Solutions to OR Questions

  1. SELECT id
    FROM orders
    WHERE gloss_qty > 4000 OR poster_qty > 4000;
  2. 2.
SELECT *
FROM orders
WHERE standard_qty = 0 AND (gloss_qty > 1000 OR poster_qty > 1000);
  1. SELECT *
    FROM accounts
    WHERE (name LIKE 'C%' OR name LIKE 'W%') 
                  AND ((primary_poc LIKE '%ana%' OR primary_poc LIKE '%Ana%') 
                  AND primary_poc NOT LIKE '%eana%');

Code

If you need a code on the https://github.com/udacity.